package com.boot.security.server.dao.mffl;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface MfflCommunityDao {

    @Select("select PROVINCE_CODE,PROVINCE_NAME from bs_province")
    List<Map<String,Object>> Level();

    @Select("select CITY_CODE,CITY_NAME from bs_city where PROVINCE_CODE = #{code}")
    List<Map<String,Object>> Leve2(String code);

    @Select("select AREA_CODE,AREA_NAME from bs_area where CITY_CODE = #{code}")
    List<Map<String,Object>> Leve3(String code);

}
